package com.dmgis.hndz.mapper;

import com.dmgis.hndz.pojo.Ybba02b;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
* @author PC
* @description 针对表【ybba02b(市级预警临时表)】的数据库操作Mapper
* @createDate 2024-01-29 17:47:43
* @Entity com.dmgis.hndz.pojo.Ybba02b
*/
@Mapper
public interface Ybba02bMapper extends BaseMapper<Ybba02b> {

// 假设定义了以下常量：

    @Insert("INSERT INTO ybba02b (ybba02b010, ybba02b020, ybba02b030, ybba02b040, ybba02b050, ybba02b060, ybba02b070" +
            ", ybba02b080, ybba02b090, ybba02b100, ybba02b110, ybba02b120" +
            ") VALUES (#{ybba02b010}, #{ybba02b020}, #{ybba02b030}, #{ybba02b040}, #{ybba02b050}, #{ybba02b060}, #{ybba02b070}" +
            ", #{ybba02b080}, #{ybba02b090}, #{ybba02b100}, #{ybba02b110}, #{ybba02b120})")
    int insert(Ybba02b ybba02b);

    List<Ybba02b> getProduct(String startTime, String endTime);

    Ybba02b getProductone(String advcode);
}




